org.nuxeo.ecm.webapp.pageproviders.contrib This contribution declares page providers used by UI components. The page provider 'tree_children' is used to list children in the tree navigation. Note the "ecm:isProxy = 0" predicate optimization that is required to simplify greatly the request performed by the tree manager when browsing on folders with a lot of files when using the Visible SQL Storage. The page provider 'default_document_suggestion' is used by default by the component performing document suggestions. PAGE_SIZE SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isProxy = 0 AND ecm:mixinType = 'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 50 PAGE_SIZE SELECT * FROM Document WHERE ecm:fulltext LIKE '?*' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 5 DEFAULT_NAVIGATION_RESULTS SELECT * FROM Document WHERE ecm:path STARTSWITH ? AND ecm:mixinType != 'Folderish' AND ecm:mixinType != 'SystemDocument' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isProxy = 0 AND ecm:isTrashed = 0 5